Overview

Brought to you by YData

Dataset statistics

Number of variables	49
Number of observations	203002
Missing cells	555
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	37.0 MiB
Average record size in memory	191.2 B

Variable types

Numeric	13
DateTime	5
Categorical	28
Boolean	3

Alerts

`id_empresa` has constant value "1"	Constant
`nombre_empresa` has constant value "Hotel 1"	Constant
`total_habitaciones_empresa` has constant value "735"	Constant
`cupo_tipo_habitacion` has constant value "2.0"	Constant
`id_moneda` has constant value "1"	Constant
`id_agencia` has a high cardinality: 120 distinct values	High cardinality
`nombre_agencia` has a high cardinality: 112 distinct values	High cardinality
`ciudad_agencia` has a high cardinality: 56 distinct values	High cardinality
`clave_estado` has a high cardinality: 148 distinct values	High cardinality
`nombre_estado` has a high cardinality: 144 distinct values	High cardinality
`ciudad_agencia` is highly overall correlated with `entidad_federativa_agencia` and 3 other fields	High correlation
`clasificacion_tipo_habitacion` is highly overall correlated with `id_tipo_habitacion` and 1 other fields	High correlation
`cliente_disp_anio_anterior` is highly overall correlated with `id_reservaciones` and 12 other fields	High correlation
`entidad_federativa_agencia` is highly overall correlated with `ciudad_agencia` and 1 other fields	High correlation
`id_canal` is highly overall correlated with `nombre_canal`	High correlation
`id_cliente_disp` is highly overall correlated with `numero_adultos` and 4 other fields	High correlation
`id_estatus_reservacion` is highly overall correlated with `nombre_estatus_reservacion`	High correlation
`id_pais_origen` is highly overall correlated with `nombre_pais_origen`	High correlation
`id_paquete` is highly overall correlated with `id_programa` and 2 other fields	High correlation
`id_programa` is highly overall correlated with `id_paquete` and 2 other fields	High correlation
`id_reservaciones` is highly overall correlated with `cliente_disp_anio_anterior` and 12 other fields	High correlation
`id_segmento` is highly overall correlated with `ciudad_agencia` and 2 other fields	High correlation
`id_tipo_habitacion` is highly overall correlated with `clasificacion_tipo_habitacion` and 1 other fields	High correlation
`nombre_canal` is highly overall correlated with `id_canal`	High correlation
`nombre_estatus_reservacion` is highly overall correlated with `id_estatus_reservacion`	High correlation
`nombre_pais_origen` is highly overall correlated with `id_pais_origen`	High correlation
`nombre_paquete` is highly overall correlated with `id_paquete` and 2 other fields	High correlation
`nombre_programa` is highly overall correlated with `id_paquete` and 2 other fields	High correlation
`nombre_segmento` is highly overall correlated with `ciudad_agencia` and 2 other fields	High correlation
`nombre_tipo_habitacion` is highly overall correlated with `clasificacion_tipo_habitacion` and 1 other fields	High correlation
`numero_adultos` is highly overall correlated with `cliente_disp_anio_anterior` and 13 other fields	High correlation
`numero_adultos_anio_anterior` is highly overall correlated with `cliente_disp_anio_anterior` and 12 other fields	High correlation
`numero_noches` is highly overall correlated with `cliente_disp_anio_anterior` and 9 other fields	High correlation
`numero_noches_anio_anterior` is highly overall correlated with `cliente_disp_anio_anterior` and 9 other fields	High correlation
`numero_personas` is highly overall correlated with `cliente_disp_anio_anterior` and 10 other fields	High correlation
`numero_personas_anio_anterior` is highly overall correlated with `cliente_disp_anio_anterior` and 9 other fields	High correlation
`pais_agencia` is highly overall correlated with `ciudad_agencia` and 3 other fields	High correlation
`reservacion` is highly overall correlated with `cliente_disp_anio_anterior` and 8 other fields	High correlation
`reservacion_anio_anterior` is highly overall correlated with `cliente_disp_anio_anterior` and 8 other fields	High correlation
`reservacion_pendiente` is highly overall correlated with `cliente_disp_anio_anterior` and 8 other fields	High correlation
`total_habitaciones` is highly overall correlated with `cliente_disp_anio_anterior` and 12 other fields	High correlation
`total_habitaciones_anio_anterior` is highly overall correlated with `cliente_disp_anio_anterior` and 12 other fields	High correlation
`total_tarifa` is highly overall correlated with `cliente_disp_anio_anterior` and 9 other fields	High correlation
`id_programa` is highly imbalanced (97.5%)	Imbalance
`nombre_programa` is highly imbalanced (97.5%)	Imbalance
`id_paquete` is highly imbalanced (60.9%)	Imbalance
`nombre_paquete` is highly imbalanced (60.9%)	Imbalance
`pais_agencia` is highly imbalanced (86.1%)	Imbalance
`id_pais_origen` is highly imbalanced (96.3%)	Imbalance
`nombre_pais_origen` is highly imbalanced (96.3%)	Imbalance
`clave_estado` is highly imbalanced (55.8%)	Imbalance
`nombre_estado` is highly imbalanced (55.5%)	Imbalance
`id_cliente_disp` is highly imbalanced (60.9%)	Imbalance
`numero_noches` is highly skewed (γ1 = 81.01891754)	Skewed
`numero_noches_anio_anterior` is highly skewed (γ1 = 82.30675646)	Skewed
`total_tarifa` is highly skewed (γ1 = 26.89402197)	Skewed
`id_reservaciones` is uniformly distributed	Uniform
`id_reservaciones` has unique values	Unique
`numero_personas` has 100803 (49.7%) zeros	Zeros
`numero_personas_anio_anterior` has 102199 (50.3%) zeros	Zeros
`numero_adultos` has 100803 (49.7%) zeros	Zeros
`numero_adultos_anio_anterior` has 102199 (50.3%) zeros	Zeros
`numero_menores` has 198413 (97.7%) zeros	Zeros
`numero_menores_anio_anterior` has 198466 (97.8%) zeros	Zeros
`numero_noches` has 101006 (49.8%) zeros	Zeros
`numero_noches_anio_anterior` has 102402 (50.4%) zeros	Zeros
`total_habitaciones` has 101049 (49.8%) zeros	Zeros
`total_habitaciones_anio_anterior` has 102445 (50.5%) zeros	Zeros
`total_tarifa` has 106391 (52.4%) zeros	Zeros
`cliente_disp_anio_anterior` has 102199 (50.3%) zeros	Zeros

Reproduction

Analysis started	2025-05-11 19:29:04.390027
Analysis finished	2025-05-11 19:29:57.886285
Duration	53.5 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

id_reservaciones
Real number (ℝ)

High correlation Uniform Unique

Distinct	203002
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	101500.5

Minimum	0
Maximum	203001
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	10150.05
Q1	50750.25
median	101500.5
Q3	152250.75
95-th percentile	192850.95
Maximum	203001
Range	203001
Interquartile range (IQR)	101500.5

Descriptive statistics

Standard deviation	58601.774
Coefficient of variation (CV)	0.57735454
Kurtosis	-1.2
Mean	101500.5
Median Absolute Deviation (MAD)	50750.5
Skewness	-8.5222189 × 10^-16
Sum	2.0604805 × 10¹⁰
Variance	3.4341679 × 10⁹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
203001	1	< 0.1%
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
Other values (202992)	202992	> 99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
203001	1	< 0.1%
203000	1	< 0.1%
202999	1	< 0.1%
202998	1	< 0.1%
202997	1	< 0.1%
202996	1	< 0.1%
202995	1	< 0.1%
202994	1	< 0.1%
202993	1	< 0.1%
202992	1	< 0.1%

fecha_hoy
Date

Distinct	824
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2019-01-02 00:00:00
Maximum	2021-12-03 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

fecha_reservacion
Date

Distinct	482
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2019-01-02 00:00:00
Maximum	2020-12-04 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

fecha_llegada
Date

Distinct	713
Distinct (%)	0.4%
Missing	2
Missing (%)	< 0.1%
Memory size	1.5 MiB

Minimum	2019-01-03 00:00:00
Maximum	2021-12-06 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

fecha_salida
Date

Distinct	722
Distinct (%)	0.4%
Missing	34
Missing (%)	< 0.1%
Memory size	1.5 MiB

Minimum	2019-01-03 00:00:00
Maximum	2021-12-06 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

numero_personas
Real number (ℝ)

High correlation Zeros

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1858652

Minimum	0
Maximum	32
Zeros	100803
Zeros (%)	49.7%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	4
Maximum	32
Range	32
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.3696288
Coefficient of variation (CV)	1.1549616
Kurtosis	17.748518
Mean	1.1858652
Median Absolute Deviation (MAD)	1
Skewness	1.7961185
Sum	240733
Variance	1.875883
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
0	100803	49.7%
2	71889	35.4%
3	15053	7.4%
4	7789	3.8%
1	4928	2.4%
5	1280	0.6%
6	785	0.4%
8	228	0.1%
7	96	< 0.1%
12	40	< 0.1%
Other values (12)	111	0.1%

Value	Count	Frequency (%)
0	100803	49.7%
1	4928	2.4%
2	71889	35.4%
3	15053	7.4%
4	7789	3.8%
5	1280	0.6%
6	785	0.4%
7	96	< 0.1%
8	228	0.1%
9	17	< 0.1%

Value	Count	Frequency (%)
32	10	< 0.1%
20	2	< 0.1%
19	5	< 0.1%
18	6	< 0.1%
17	13	< 0.1%
16	8	< 0.1%
15	2	< 0.1%
14	6	< 0.1%
13	3	< 0.1%
12	40	< 0.1%

numero_personas_anio_anterior
Real number (ℝ)

High correlation Zeros

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.17055

Minimum	0
Maximum	32
Zeros	102199
Zeros (%)	50.3%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	4
Maximum	32
Range	32
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.3680725
Coefficient of variation (CV)	1.1687433
Kurtosis	17.777041
Mean	1.17055
Median Absolute Deviation (MAD)	0
Skewness	1.8060301
Sum	237624
Variance	1.8716224
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
0	102199	50.3%
2	70655	34.8%
3	14990	7.4%
4	7732	3.8%
1	4913	2.4%
5	1276	0.6%
6	779	0.4%
8	215	0.1%
7	96	< 0.1%
12	38	< 0.1%
Other values (12)	109	0.1%

Value	Count	Frequency (%)
0	102199	50.3%
1	4913	2.4%
2	70655	34.8%
3	14990	7.4%
4	7732	3.8%
5	1276	0.6%
6	779	0.4%
7	96	< 0.1%
8	215	0.1%
9	17	< 0.1%

Value	Count	Frequency (%)
32	10	< 0.1%
20	2	< 0.1%
19	5	< 0.1%
18	6	< 0.1%
17	13	< 0.1%
16	8	< 0.1%
15	1	< 0.1%
14	6	< 0.1%
13	3	< 0.1%
12	38	< 0.1%

numero_adultos
Real number (ℝ)

High correlation Zeros

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0947084

Minimum	0
Maximum	15
Zeros	100803
Zeros (%)	49.7%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	3
Maximum	15
Range	15
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.2070762
Coefficient of variation (CV)	1.1026463
Kurtosis	4.3490022
Mean	1.0947084
Median Absolute Deviation (MAD)	1
Skewness	1.057326
Sum	222228
Variance	1.4570329
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	100803	49.7%
2	80295	39.6%
3	12016	5.9%
1	5654	2.8%
4	2962	1.5%
5	536	0.3%
6	427	0.2%
8	156	0.1%
7	43	< 0.1%
15	24	< 0.1%
Other values (6)	86	< 0.1%

Value	Count	Frequency (%)
0	100803	49.7%
1	5654	2.8%
2	80295	39.6%
3	12016	5.9%
4	2962	1.5%
5	536	0.3%
6	427	0.2%
7	43	< 0.1%
8	156	0.1%
9	20	< 0.1%

Value	Count	Frequency (%)
15	24	< 0.1%
14	8	< 0.1%
13	4	< 0.1%
12	22	< 0.1%
11	9	< 0.1%
10	23	< 0.1%
9	20	< 0.1%
8	156	0.1%
7	43	< 0.1%
6	427	0.2%

numero_adultos_anio_anterior
Real number (ℝ)

High correlation Zeros

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0796938

Minimum	0
Maximum	15
Zeros	102199
Zeros (%)	50.3%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	3
Maximum	15
Range	15
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.2046937
Coefficient of variation (CV)	1.1157735
Kurtosis	4.2151962
Mean	1.0796938
Median Absolute Deviation (MAD)	0
Skewness	1.0595136
Sum	219180
Variance	1.451287
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	102199	50.3%
2	79038	38.9%
3	11946	5.9%
1	5638	2.8%
4	2933	1.4%
5	534	0.3%
6	422	0.2%
8	143	0.1%
7	43	< 0.1%
10	23	< 0.1%
Other values (6)	83	< 0.1%

Value	Count	Frequency (%)
0	102199	50.3%
1	5638	2.8%
2	79038	38.9%
3	11946	5.9%
4	2933	1.4%
5	534	0.3%
6	422	0.2%
7	43	< 0.1%
8	143	0.1%
9	19	< 0.1%

Value	Count	Frequency (%)
15	23	< 0.1%
14	8	< 0.1%
13	4	< 0.1%
12	20	< 0.1%
11	9	< 0.1%
10	23	< 0.1%
9	19	< 0.1%
8	143	0.1%
7	43	< 0.1%
6	422	0.2%

numero_menores
Real number (ℝ)

Zeros

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.034108038

Minimum	0
Maximum	15
Zeros	198413
Zeros (%)	97.7%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	15
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.26518667
Coefficient of variation (CV)	7.7749023
Kurtosis	582.05071
Mean	0.034108038
Median Absolute Deviation (MAD)	0
Skewness	16.064875
Sum	6924
Variance	0.070323969
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	198413	97.7%
1	2730	1.3%
2	1619	0.8%
3	168	0.1%
4	31	< 0.1%
5	17	< 0.1%
15	10	< 0.1%
7	7	< 0.1%
6	6	< 0.1%
8	1	< 0.1%

Value	Count	Frequency (%)
0	198413	97.7%
1	2730	1.3%
2	1619	0.8%
3	168	0.1%
4	31	< 0.1%
5	17	< 0.1%
6	6	< 0.1%
7	7	< 0.1%
8	1	< 0.1%
15	10	< 0.1%

Value	Count	Frequency (%)
15	10	< 0.1%
8	1	< 0.1%
7	7	< 0.1%
6	6	< 0.1%
5	17	< 0.1%
4	31	< 0.1%
3	168	0.1%
2	1619	0.8%
1	2730	1.3%
0	198413	97.7%

numero_menores_anio_anterior
Real number (ℝ)

Zeros

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.033733658

Minimum	0
Maximum	15
Zeros	198466
Zeros (%)	97.8%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	15
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.26404323
Coefficient of variation (CV)	7.8272933
Kurtosis	591.82119
Mean	0.033733658
Median Absolute Deviation (MAD)	0
Skewness	16.215274
Sum	6848
Variance	0.069718829
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	198466	97.8%
1	2697	1.3%
2	1602	0.8%
3	165	0.1%
4	31	< 0.1%
5	17	< 0.1%
15	10	< 0.1%
7	7	< 0.1%
6	6	< 0.1%
8	1	< 0.1%

Value	Count	Frequency (%)
0	198466	97.8%
1	2697	1.3%
2	1602	0.8%
3	165	0.1%
4	31	< 0.1%
5	17	< 0.1%
6	6	< 0.1%
7	7	< 0.1%
8	1	< 0.1%
15	10	< 0.1%

Value	Count	Frequency (%)
15	10	< 0.1%
8	1	< 0.1%
7	7	< 0.1%
6	6	< 0.1%
5	17	< 0.1%
4	31	< 0.1%
3	165	0.1%
2	1602	0.8%
1	2697	1.3%
0	198466	97.8%

numero_noches
Real number (ℝ)

High correlation Skewed Zeros

Distinct	42
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6800278

Minimum	0
Maximum	687
Zeros	101006
Zeros (%)	49.8%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	3
95-th percentile	6
Maximum	687
Range	687
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.866189
Coefficient of variation (CV)	1.7060367
Kurtosis	17214.397
Mean	1.6800278
Median Absolute Deviation (MAD)	1
Skewness	81.018918
Sum	341049
Variance	8.2150394
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
0	101006	49.8%
3	38707	19.1%
2	28782	14.2%
4	16407	8.1%
7	8683	4.3%
1	4702	2.3%
5	2511	1.2%
6	1034	0.5%
14	643	0.3%
8	142	0.1%
Other values (32)	385	0.2%

Value	Count	Frequency (%)
0	101006	49.8%
1	4702	2.3%
2	28782	14.2%
3	38707	19.1%
4	16407	8.1%
5	2511	1.2%
6	1034	0.5%
7	8683	4.3%
8	142	0.1%
9	67	< 0.1%

Value	Count	Frequency (%)
687	1	< 0.1%
321	1	< 0.1%
191	1	< 0.1%
182	3	< 0.1%
89	2	< 0.1%
87	2	< 0.1%
84	1	< 0.1%
81	1	< 0.1%
74	1	< 0.1%
63	2	< 0.1%

numero_noches_anio_anterior
Real number (ℝ)

High correlation Skewed Zeros

Distinct	41
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6560428

Minimum	0
Maximum	687
Zeros	102402
Zeros (%)	50.4%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	6
Maximum	687
Range	687
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.8479579
Coefficient of variation (CV)	1.7197369
Kurtosis	17653.507
Mean	1.6560428
Median Absolute Deviation (MAD)	0
Skewness	82.306756
Sum	336180
Variance	8.1108641
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
0	102402	50.4%
3	38025	18.7%
2	28423	14.0%
4	16169	8.0%
7	8623	4.2%
1	4696	2.3%
5	2496	1.2%
6	1032	0.5%
14	643	0.3%
8	140	0.1%
Other values (31)	353	0.2%

Value	Count	Frequency (%)
0	102402	50.4%
1	4696	2.3%
2	28423	14.0%
3	38025	18.7%
4	16169	8.0%
5	2496	1.2%
6	1032	0.5%
7	8623	4.2%
8	140	0.1%
9	67	< 0.1%

Value	Count	Frequency (%)
687	1	< 0.1%
321	1	< 0.1%
191	1	< 0.1%
182	3	< 0.1%
87	2	< 0.1%
84	1	< 0.1%
81	1	< 0.1%
74	1	< 0.1%
63	2	< 0.1%
59	1	< 0.1%

total_habitaciones
Real number (ℝ)

High correlation Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.50558123

Minimum	0
Maximum	6
Zeros	101049
Zeros (%)	49.8%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	1
Maximum	6
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.50875061
Coefficient of variation (CV)	1.0062688
Kurtosis	-1.2383857
Mean	0.50558123
Median Absolute Deviation (MAD)	1
Skewness	0.1342456
Sum	102634
Variance	0.25882718
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	101467	50.0%
0	101049	49.8%
2	308	0.2%
3	166	0.1%
4	8	< 0.1%
5	3	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
0	101049	49.8%
1	101467	50.0%
2	308	0.2%
3	166	0.1%
4	8	< 0.1%
5	3	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
6	1	< 0.1%
5	3	< 0.1%
4	8	< 0.1%
3	166	0.1%
2	308	0.2%
1	101467	50.0%
0	101049	49.8%

total_habitaciones_anio_anterior
Real number (ℝ)

High correlation Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.49858622

Minimum	0
Maximum	6
Zeros	102445
Zeros (%)	50.5%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	1
Maximum	6
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.50848871
Coefficient of variation (CV)	1.0198611
Kurtosis	-1.2480827
Mean	0.49858622
Median Absolute Deviation (MAD)	0
Skewness	0.15773602
Sum	101214
Variance	0.25856077
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	102445	50.5%
1	100089	49.3%
2	296	0.1%
3	160	0.1%
4	8	< 0.1%
5	3	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
0	102445	50.5%
1	100089	49.3%
2	296	0.1%
3	160	0.1%
4	8	< 0.1%
5	3	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
6	1	< 0.1%
5	3	< 0.1%
4	8	< 0.1%
3	160	0.1%
2	296	0.1%
1	100089	49.3%
0	102445	50.5%

id_programa
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.5 KiB

1	202510
0	492

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	203002
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	202510	99.8%
0	492	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	202510	99.8%
0	492	0.2%

Most occurring characters

Value	Count	Frequency (%)
1	202510	99.8%
0	492	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	202510	99.8%
0	492	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	202510	99.8%
0	492	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	202510	99.8%
0	492	0.2%

nombre_programa
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.5 KiB

Ninguno	202510
Sin Definir	492

Length

Max length	11
Median length	7
Mean length	7.0096945
Min length	7

Characters and Unicode

Total characters	1422982
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ninguno
2nd row	Ninguno
3rd row	Ninguno
4th row	Ninguno
5th row	Ninguno

Common Values

Value	Count	Frequency (%)
Ninguno	202510	99.8%
Sin Definir	492	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ninguno	202510	99.5%
sin	492	0.2%
definir	492	0.2%

Most occurring characters

Value	Count	Frequency (%)
n	406004	28.5%
i	203986	14.3%
N	202510	14.2%
g	202510	14.2%
u	202510	14.2%
o	202510	14.2%
S	492	< 0.1%
	492	< 0.1%
D	492	< 0.1%
e	492	< 0.1%
Other values (2)	984	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1422982	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	406004	28.5%
i	203986	14.3%
N	202510	14.2%
g	202510	14.2%
u	202510	14.2%
o	202510	14.2%
S	492	< 0.1%
	492	< 0.1%
D	492	< 0.1%
e	492	< 0.1%
Other values (2)	984	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1422982	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	406004	28.5%
i	203986	14.3%
N	202510	14.2%
g	202510	14.2%
u	202510	14.2%
o	202510	14.2%
S	492	< 0.1%
	492	< 0.1%
D	492	< 0.1%
e	492	< 0.1%
Other values (2)	984	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1422982	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	406004	28.5%
i	203986	14.3%
N	202510	14.2%
g	202510	14.2%
u	202510	14.2%
o	202510	14.2%
S	492	< 0.1%
	492	< 0.1%
D	492	< 0.1%
e	492	< 0.1%
Other values (2)	984	0.1%

id_paquete
Categorical

High correlation Imbalance

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.6 KiB

1	117658
2	84718
0	492
5	92
3	40

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	203002
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	2
3rd row	1
4th row	2
5th row	1

Common Values

Value	Count	Frequency (%)
1	117658	58.0%
2	84718	41.7%
0	492	0.2%
5	92	< 0.1%
3	40	< 0.1%
4	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	117658	58.0%
2	84718	41.7%
0	492	0.2%
5	92	< 0.1%
3	40	< 0.1%
4	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	117658	58.0%
2	84718	41.7%
0	492	0.2%
5	92	< 0.1%
3	40	< 0.1%
4	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	117658	58.0%
2	84718	41.7%
0	492	0.2%
5	92	< 0.1%
3	40	< 0.1%
4	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	117658	58.0%
2	84718	41.7%
0	492	0.2%
5	92	< 0.1%
3	40	< 0.1%
4	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	117658	58.0%
2	84718	41.7%
0	492	0.2%
5	92	< 0.1%
3	40	< 0.1%
4	2	< 0.1%

nombre_paquete
Categorical

High correlation Imbalance

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.6 KiB

Walk In	117658
Ninguno	84718
Sin Definir	492
Entre Semana	92
Lunamielero	40

Length

Max length	13
Median length	7
Mean length	7.0128078
Min length	7

Characters and Unicode

Total characters	1423614
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Walk In
2nd row	Ninguno
3rd row	Walk In
4th row	Ninguno
5th row	Walk In

Common Values

Value	Count	Frequency (%)
Walk In	117658	58.0%
Ninguno	84718	41.7%
Sin Definir	492	0.2%
Entre Semana	92	< 0.1%
Lunamielero	40	< 0.1%
Fin De Semana	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
walk	117658	36.6%
in	117658	36.6%
ninguno	84718	26.4%
sin	492	0.2%
definir	492	0.2%
semana	94	< 0.1%
entre	92	< 0.1%
lunamielero	40	< 0.1%
fin	2	< 0.1%
de	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
n	288306	20.3%
	118246	8.3%
a	117886	8.3%
l	117698	8.3%
k	117658	8.3%
W	117658	8.3%
I	117658	8.3%
i	86236	6.1%
o	84758	6.0%
u	84758	6.0%
Other values (12)	172752	12.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1423614	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	288306	20.3%
	118246	8.3%
a	117886	8.3%
l	117698	8.3%
k	117658	8.3%
W	117658	8.3%
I	117658	8.3%
i	86236	6.1%
o	84758	6.0%
u	84758	6.0%
Other values (12)	172752	12.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1423614	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	288306	20.3%
	118246	8.3%
a	117886	8.3%
l	117698	8.3%
k	117658	8.3%
W	117658	8.3%
I	117658	8.3%
i	86236	6.1%
o	84758	6.0%
u	84758	6.0%
Other values (12)	172752	12.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1423614	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	288306	20.3%
	118246	8.3%
a	117886	8.3%
l	117698	8.3%
k	117658	8.3%
W	117658	8.3%
I	117658	8.3%
i	86236	6.1%
o	84758	6.0%
u	84758	6.0%
Other values (12)	172752	12.1%

id_segmento
Categorical

High correlation

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	199.1 KiB

17	73098
14	27298
5	26874
16	16872
12	15887
Other values (15)	42973

Length

Max length	2
Median length	2
Mean length	1.7744702
Min length	1

Characters and Unicode

Total characters	360221
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	14
2nd row	14
3rd row	14
4th row	14
5th row	5

Common Values

Value	Count	Frequency (%)
17	73098	36.0%
14	27298	13.4%
5	26874	13.2%
16	16872	8.3%
12	15887	7.8%
18	9082	4.5%
1	6059	3.0%
13	5770	2.8%
8	5195	2.6%
10	3212	1.6%
Other values (10)	13655	6.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
17	73098	36.0%
14	27298	13.4%
5	26874	13.2%
16	16872	8.3%
12	15887	7.8%
18	9082	4.5%
1	6059	3.0%
13	5770	2.8%
8	5195	2.6%
10	3212	1.6%
Other values (10)	13655	6.7%

Most occurring characters

Value	Count	Frequency (%)
1	166089	46.1%
7	75118	20.9%
4	27975	7.8%
5	26878	7.5%
6	18498	5.1%
2	15921	4.4%
8	14277	4.0%
9	5901	1.6%
3	5774	1.6%
0	3790	1.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	360221	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	166089	46.1%
7	75118	20.9%
4	27975	7.8%
5	26878	7.5%
6	18498	5.1%
2	15921	4.4%
8	14277	4.0%
9	5901	1.6%
3	5774	1.6%
0	3790	1.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	360221	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	166089	46.1%
7	75118	20.9%
4	27975	7.8%
5	26878	7.5%
6	18498	5.1%
2	15921	4.4%
8	14277	4.0%
9	5901	1.6%
3	5774	1.6%
0	3790	1.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	360221	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	166089	46.1%
7	75118	20.9%
4	27975	7.8%
5	26878	7.5%
6	18498	5.1%
2	15921	4.4%
8	14277	4.0%
9	5901	1.6%
3	5774	1.6%
0	3790	1.1%

nombre_segmento
Categorical

High correlation

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	199.1 KiB

Tour Operators Domestic	73098
Individual Ep/vac. Club	27298
Ecommerce Ota Domestic	26874
Individual Leisure/package	16872
Gro. & Conv. Meetings	15887
Other values (15)	42973

Length

Max length	29
Median length	23
Mean length	23.380341
Min length	11

Characters and Unicode

Total characters	4746256
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Individual Ep/vac. Club
2nd row	Individual Ep/vac. Club
3rd row	Individual Ep/vac. Club
4th row	Individual Ep/vac. Club
5th row	Ecommerce Ota Domestic

Common Values

Value	Count	Frequency (%)
Tour Operators Domestic	73098	36.0%
Individual Ep/vac. Club	27298	13.4%
Ecommerce Ota Domestic	26874	13.2%
Individual Leisure/package	16872	8.3%
Gro. & Conv. Meetings	15887	7.8%
Tour Operators Internationals	9082	4.5%
Complementaries Cortesias	6059	3.0%
Individual Business/loyalty	5770	2.8%
Ecommerce Website	5195	2.6%
Gro. & Conv. Incentive Soc.	3212	1.6%
Other values (10)	13655	6.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
domestic	99972	16.5%
tour	85365	14.1%
operators	85365	14.1%
individual	49944	8.3%
ecommerce	35715	5.9%
club	29318	4.8%
ota	28500	4.7%
ep/vac	27298	4.5%
gro	24626	4.1%
	24626	4.1%
Other values (22)	114410	18.9%

Most occurring characters

Value	Count	Frequency (%)
e	416470	8.8%
	402137	8.5%
o	399609	8.4%
r	362988	7.6%
i	285755	6.0%
s	284584	6.0%
t	278158	5.9%
a	271433	5.7%
c	224028	4.7%
u	190080	4.0%
Other values (28)	1631014	34.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4746256	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	416470	8.8%
	402137	8.5%
o	399609	8.4%
r	362988	7.6%
i	285755	6.0%
s	284584	6.0%
t	278158	5.9%
a	271433	5.7%
c	224028	4.7%
u	190080	4.0%
Other values (28)	1631014	34.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4746256	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	416470	8.8%
	402137	8.5%
o	399609	8.4%
r	362988	7.6%
i	285755	6.0%
s	284584	6.0%
t	278158	5.9%
a	271433	5.7%
c	224028	4.7%
u	190080	4.0%
Other values (28)	1631014	34.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4746256	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	416470	8.8%
	402137	8.5%
o	399609	8.4%
r	362988	7.6%
i	285755	6.0%
s	284584	6.0%
t	278158	5.9%
a	271433	5.7%
c	224028	4.7%
u	190080	4.0%
Other values (28)	1631014	34.4%

id_agencia
Categorical

High cardinality

Distinct	120
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	203.4 KiB

99	31553
112	25735
86	13031
14	12337
116	8846
Other values (115)	111500

Length

Max length	3
Median length	2
Mean length	2.2083477
Min length	1

Characters and Unicode

Total characters	448299
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	112
2nd row	112
3rd row	112
4th row	112
5th row	14

Common Values

Value	Count	Frequency (%)
99	31553	15.5%
112	25735	12.7%
86	13031	6.4%
14	12337	6.1%
116	8846	4.4%
33	7596	3.7%
93	7160	3.5%
89	6582	3.2%
113	6337	3.1%
32	4575	2.3%
Other values (110)	79250	39.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
99	31553	15.5%
112	25735	12.7%
86	13031	6.4%
14	12337	6.1%
116	8846	4.4%
33	7596	3.7%
93	7160	3.5%
89	6582	3.2%
113	6337	3.1%
32	4575	2.3%
Other values (110)	79250	39.0%

Most occurring characters

Value	Count	Frequency (%)
1	126778	28.3%
9	88800	19.8%
2	57668	12.9%
3	48962	10.9%
6	36482	8.1%
8	28336	6.3%
4	26026	5.8%
0	12477	2.8%
7	12359	2.8%
5	10411	2.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	448299	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	126778	28.3%
9	88800	19.8%
2	57668	12.9%
3	48962	10.9%
6	36482	8.1%
8	28336	6.3%
4	26026	5.8%
0	12477	2.8%
7	12359	2.8%
5	10411	2.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	448299	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	126778	28.3%
9	88800	19.8%
2	57668	12.9%
3	48962	10.9%
6	36482	8.1%
8	28336	6.3%
4	26026	5.8%
0	12477	2.8%
7	12359	2.8%
5	10411	2.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	448299	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	126778	28.3%
9	88800	19.8%
2	57668	12.9%
3	48962	10.9%
6	36482	8.1%
8	28336	6.3%
4	26026	5.8%
0	12477	2.8%
7	12359	2.8%
5	10411	2.3%

nombre_agencia
Categorical

High cardinality

Distinct	112
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	203.3 KiB

Hoteles S.a.	42342
Quality Services Morelia	31553
Clientes Particulares	13031
Bestday Travel Group	12337
Sunwing Vacations	8846
Other values (107)	94893

Length

Max length	50
Median length	48
Mean length	20.876479
Min length	3

Characters and Unicode

Total characters	4237967
Distinct characters	67
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hoteles S.a.
2nd row	Hoteles S.a.
3rd row	Hoteles S.a.
4th row	Hoteles S.a.
5th row	Bestday Travel Group

Common Values

Value	Count	Frequency (%)
Hoteles S.a.	42342	20.9%
Quality Services Morelia	31553	15.5%
Clientes Particulares	13031	6.4%
Bestday Travel Group	12337	6.1%
Sunwing Vacations	8846	4.4%
Cruz Azul Corporativo	7596	3.7%
Quality Services Leon	7160	3.5%
Pricetravel Holding	6582	3.2%
Operadora De Viajes Solatino	6337	3.1%
Quality Services Aguascalientes	4195	2.1%
Other values (102)	63023	31.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
services	51133	8.8%
quality	49167	8.4%
s.a	48944	8.4%
hoteles	42342	7.2%
morelia	37248	6.4%
de	26941	4.6%
group	17293	3.0%
travel	16163	2.8%
particulares	13031	2.2%
clientes	13031	2.2%
Other values (247)	268769	46.0%

Most occurring characters

Value	Count	Frequency (%)
e	455974	10.8%
	381060	9.0%
a	364207	8.6%
i	297220	7.0%
r	277984	6.6%
o	261207	6.2%
l	243489	5.7%
t	210255	5.0%
s	204322	4.8%
u	141851	3.3%
Other values (57)	1400398	33.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4237967	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	455974	10.8%
	381060	9.0%
a	364207	8.6%
i	297220	7.0%
r	277984	6.6%
o	261207	6.2%
l	243489	5.7%
t	210255	5.0%
s	204322	4.8%
u	141851	3.3%
Other values (57)	1400398	33.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4237967	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	455974	10.8%
	381060	9.0%
a	364207	8.6%
i	297220	7.0%
r	277984	6.6%
o	261207	6.2%
l	243489	5.7%
t	210255	5.0%
s	204322	4.8%
u	141851	3.3%
Other values (57)	1400398	33.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4237967	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	455974	10.8%
	381060	9.0%
a	364207	8.6%
i	297220	7.0%
r	277984	6.6%
o	261207	6.2%
l	243489	5.7%
t	210255	5.0%
s	204322	4.8%
u	141851	3.3%
Other values (57)	1400398	33.0%

ciudad_agencia
Categorical

High cardinality High correlation

Distinct	56
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	200.9 KiB

Morelia	60055
Mexico City	37707
Ixtapa	24175
Cancún	18919
Toronto	8846
Other values (51)	53300

Length

Max length	15
Median length	14
Mean length	8.1781953
Min length	4

Characters and Unicode

Total characters	1660190
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mexico City
2nd row	Mexico City
3rd row	Mexico City
4th row	Mexico City
5th row	Cancún

Common Values

Value	Count	Frequency (%)
Morelia	60055	29.6%
Mexico City	37707	18.6%
Ixtapa	24175	11.9%
Cancún	18919	9.3%
Toronto	8846	4.4%
Del. Coyoacan	8392	4.1%
Cancun	7583	3.7%
Leon	6069	3.0%
Zapopan	3917	1.9%
Cd De Mexico	2458	1.2%
Other values (46)	24881	12.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
morelia	60055	22.4%
mexico	42909	16.0%
city	37733	14.0%
ixtapa	24175	9.0%
cancún	18919	7.0%
coyoacan	9308	3.5%
toronto	8846	3.3%
del	8652	3.2%
cancun	7583	2.8%
de	6376	2.4%
Other values (54)	44114	16.4%

Most occurring characters

Value	Count	Frequency (%)
a	193777	11.7%
o	167958	10.1%
i	157340	9.5%
e	141709	8.5%
M	109373	6.6%
n	93606	5.6%
c	84015	5.1%
C	81939	4.9%
t	80242	4.8%
r	79335	4.8%
Other values (41)	470896	28.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1660190	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	193777	11.7%
o	167958	10.1%
i	157340	9.5%
e	141709	8.5%
M	109373	6.6%
n	93606	5.6%
c	84015	5.1%
C	81939	4.9%
t	80242	4.8%
r	79335	4.8%
Other values (41)	470896	28.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1660190	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	193777	11.7%
o	167958	10.1%
i	157340	9.5%
e	141709	8.5%
M	109373	6.6%
n	93606	5.6%
c	84015	5.1%
C	81939	4.9%
t	80242	4.8%
r	79335	4.8%
Other values (41)	470896	28.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1660190	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	193777	11.7%
o	167958	10.1%
i	157340	9.5%
e	141709	8.5%
M	109373	6.6%
n	93606	5.6%
c	84015	5.1%
C	81939	4.9%
t	80242	4.8%
r	79335	4.8%
Other values (41)	470896	28.4%

entidad_federativa_agencia
Categorical

High correlation

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	199.1 KiB

Michoacán	62725
México	51136
Guerrero	28774
Quintana Roo	26502
Distrito Federal	9442
Other values (18)	24423

Length

Max length	16
Median length	15
Mean length	8.731978
Min length	5

Characters and Unicode

Total characters	1772609
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	México
2nd row	México
3rd row	México
4th row	México
5th row	Quintana Roo

Common Values

Value	Count	Frequency (%)
Michoacán	62725	30.9%
México	51136	25.2%
Guerrero	28774	14.2%
Quintana Roo	26502	13.1%
Distrito Federal	9442	4.7%
Ontario	8868	4.4%
Guanajuato	6117	3.0%
Jalisco	5394	2.7%
Querétaro	1050	0.5%
Aguascalientes	1016	0.5%
Other values (13)	1978	1.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
michoacán	62725	26.2%
méxico	51136	21.4%
guerrero	28774	12.0%
quintana	26502	11.1%
roo	26502	11.1%
distrito	9442	3.9%
federal	9442	3.9%
ontario	8868	3.7%
guanajuato	6117	2.6%
jalisco	5394	2.3%
Other values (19)	4422	1.8%

Most occurring characters

Value	Count	Frequency (%)
o	228652	12.9%
c	183194	10.3%
i	176871	10.0%
a	163076	9.2%
n	132854	7.5%
r	117344	6.6%
M	114239	6.4%
e	80236	4.5%
u	69874	3.9%
h	62845	3.5%
Other values (30)	443424	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1772609	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	228652	12.9%
c	183194	10.3%
i	176871	10.0%
a	163076	9.2%
n	132854	7.5%
r	117344	6.6%
M	114239	6.4%
e	80236	4.5%
u	69874	3.9%
h	62845	3.5%
Other values (30)	443424	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1772609	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	228652	12.9%
c	183194	10.3%
i	176871	10.0%
a	163076	9.2%
n	132854	7.5%
r	117344	6.6%
M	114239	6.4%
e	80236	4.5%
u	69874	3.9%
h	62845	3.5%
Other values (30)	443424	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1772609	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	228652	12.9%
c	183194	10.3%
i	176871	10.0%
a	163076	9.2%
n	132854	7.5%
r	117344	6.6%
M	114239	6.4%
e	80236	4.5%
u	69874	3.9%
h	62845	3.5%
Other values (30)	443424	25.0%

pais_agencia
Categorical

High correlation Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.6 KiB

México	192788
Canada	8868
Estados Unidos	1072
Costa Rica	198
Tarifas	76

Length

Max length	14
Median length	6
Mean length	6.0465217
Min length	6

Characters and Unicode

Total characters	1227456
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	México
2nd row	México
3rd row	México
4th row	México
5th row	México

Common Values

Value	Count	Frequency (%)
México	192788	95.0%
Canada	8868	4.4%
Estados Unidos	1072	0.5%
Costa Rica	198	0.1%
Tarifas	76	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
méxico	192788	94.4%
canada	8868	4.3%
estados	1072	0.5%
unidos	1072	0.5%
costa	198	0.1%
rica	198	0.1%
tarifas	76	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
o	195130	15.9%
i	194134	15.8%
c	192986	15.7%
x	192788	15.7%
é	192788	15.7%
M	192788	15.7%
a	28224	2.3%
d	11012	0.9%
n	9940	0.8%
C	9066	0.7%
Other values (9)	8600	0.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1227456	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	195130	15.9%
i	194134	15.8%
c	192986	15.7%
x	192788	15.7%
é	192788	15.7%
M	192788	15.7%
a	28224	2.3%
d	11012	0.9%
n	9940	0.8%
C	9066	0.7%
Other values (9)	8600	0.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1227456	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	195130	15.9%
i	194134	15.8%
c	192986	15.7%
x	192788	15.7%
é	192788	15.7%
M	192788	15.7%
a	28224	2.3%
d	11012	0.9%
n	9940	0.8%
C	9066	0.7%
Other values (9)	8600	0.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1227456	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	195130	15.9%
i	194134	15.8%
c	192986	15.7%
x	192788	15.7%
é	192788	15.7%
M	192788	15.7%
a	28224	2.3%
d	11012	0.9%
n	9940	0.8%
C	9066	0.7%
Other values (9)	8600	0.7%

id_empresa
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.5 KiB

1	203002

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	203002
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	203002	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	203002	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	203002	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	203002	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	203002	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	203002	100.0%

nombre_empresa
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.5 KiB

Hotel 1	203002

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	1421014
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hotel 1
2nd row	Hotel 1
3rd row	Hotel 1
4th row	Hotel 1
5th row	Hotel 1

Common Values

Value	Count	Frequency (%)
Hotel 1	203002	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hotel	203002	50.0%
1	203002	50.0%

Most occurring characters

Value	Count	Frequency (%)
H	203002	14.3%
o	203002	14.3%
t	203002	14.3%
e	203002	14.3%
l	203002	14.3%
	203002	14.3%
1	203002	14.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1421014	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
H	203002	14.3%
o	203002	14.3%
t	203002	14.3%
e	203002	14.3%
l	203002	14.3%
	203002	14.3%
1	203002	14.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1421014	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
H	203002	14.3%
o	203002	14.3%
t	203002	14.3%
e	203002	14.3%
l	203002	14.3%
	203002	14.3%
1	203002	14.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1421014	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
H	203002	14.3%
o	203002	14.3%
t	203002	14.3%
e	203002	14.3%
l	203002	14.3%
	203002	14.3%
1	203002	14.3%

total_habitaciones_empresa
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

735	203002

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	609006
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	735
2nd row	735
3rd row	735
4th row	735
5th row	735

Common Values

Value	Count	Frequency (%)
735	203002	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
735	203002	100.0%

Most occurring characters

Value	Count	Frequency (%)
7	203002	33.3%
3	203002	33.3%
5	203002	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	609006	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
7	203002	33.3%
3	203002	33.3%
5	203002	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	609006	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
7	203002	33.3%
3	203002	33.3%
5	203002	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	609006	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
7	203002	33.3%
3	203002	33.3%
5	203002	33.3%

id_tipo_habitacion
Categorical

High correlation

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	199.6 KiB

4	52796
19	51281
17	30868
6	13910
25	11124
Other values (23)	43023

Length

Max length	2
Median length	2
Mean length	1.6264323
Min length	1

Characters and Unicode

Total characters	330169
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	25
2nd row	25
3rd row	23
4th row	24
5th row	4

Common Values

Value	Count	Frequency (%)
4	52796	26.0%
19	51281	25.3%
17	30868	15.2%
6	13910	6.9%
25	11124	5.5%
13	10510	5.2%
5	6091	3.0%
23	5793	2.9%
26	4909	2.4%
24	3849	1.9%
Other values (18)	11871	5.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
4	52796	26.0%
19	51281	25.3%
17	30868	15.2%
6	13910	6.9%
25	11124	5.5%
13	10510	5.2%
5	6091	3.0%
23	5793	2.9%
26	4909	2.4%
24	3849	1.9%
Other values (18)	11871	5.8%

Most occurring characters

Value	Count	Frequency (%)
1	98405	29.8%
4	56983	17.3%
9	51417	15.6%
7	34996	10.6%
2	33669	10.2%
6	18885	5.7%
5	17365	5.3%
3	16493	5.0%
8	1446	0.4%
0	510	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	330169	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	98405	29.8%
4	56983	17.3%
9	51417	15.6%
7	34996	10.6%
2	33669	10.2%
6	18885	5.7%
5	17365	5.3%
3	16493	5.0%
8	1446	0.4%
0	510	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	330169	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	98405	29.8%
4	56983	17.3%
9	51417	15.6%
7	34996	10.6%
2	33669	10.2%
6	18885	5.7%
5	17365	5.3%
3	16493	5.0%
8	1446	0.4%
0	510	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	330169	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	98405	29.8%
4	56983	17.3%
9	51417	15.6%
7	34996	10.6%
2	33669	10.2%
6	18885	5.7%
5	17365	5.3%
3	16493	5.0%
8	1446	0.4%
0	510	0.2%

nombre_tipo_habitacion
Categorical

High correlation

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	199.6 KiB

Luxury 2q Sn12gsu	52796
Estd Db Sn12ast	51281
Estd C/balcon Sn12asb	30868
Luxury 1k Sn12gsu	13910
Estd 2q Sn12mst	11124
Other values (23)	43023

Length

Max length	22
Median length	21
Mean length	17.6079
Min length	11

Characters and Unicode

Total characters	3574439
Distinct characters	42
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Estd 2q Sn12mst
2nd row	Estd 2q Sn12mst
3rd row	Jr Suite 1k Sn12mjs
4th row	Jr Suite 2q Sn12mjs
5th row	Luxury 2q Sn12gsu

Common Values

Value	Count	Frequency (%)
Luxury 2q Sn12gsu	52796	26.0%
Estd Db Sn12ast	51281	25.3%
Estd C/balcon Sn12asb	30868	15.2%
Luxury 1k Sn12gsu	13910	6.9%
Estd 2q Sn12mst	11124	5.5%
Sup Luj King Sn12asb	10510	5.2%
Luxury 2q Sb Sn12gsu	6091	3.0%
Jr Suite 1k Sn12mjs	5793	2.9%
Mv Luxury 2q Sn12gsu	4909	2.4%
Jr Suite 2q Sn12mjs	3849	1.9%
Other values (18)	11871	5.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
estd	96111	14.9%
sn12gsu	80304	12.5%
luxury	79682	12.4%
2q	78998	12.3%
db	51805	8.1%
sn12ast	51281	8.0%
sn12asb	43060	6.7%
c/balcon	30868	4.8%
1k	21882	3.4%
suite	15729	2.4%
Other values (28)	93478	14.5%

Most occurring characters

Value	Count	Frequency (%)
	440196	12.3%
s	303642	8.5%
2	281990	7.9%
u	277429	7.8%
n	246696	6.9%
S	235266	6.6%
1	227026	6.4%
t	176397	4.9%
a	140160	3.9%
b	132162	3.7%
Other values (32)	1113475	31.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3574439	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	440196	12.3%
s	303642	8.5%
2	281990	7.9%
u	277429	7.8%
n	246696	6.9%
S	235266	6.6%
1	227026	6.4%
t	176397	4.9%
a	140160	3.9%
b	132162	3.7%
Other values (32)	1113475	31.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3574439	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	440196	12.3%
s	303642	8.5%
2	281990	7.9%
u	277429	7.8%
n	246696	6.9%
S	235266	6.6%
1	227026	6.4%
t	176397	4.9%
a	140160	3.9%
b	132162	3.7%
Other values (32)	1113475	31.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3574439	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	440196	12.3%
s	303642	8.5%
2	281990	7.9%
u	277429	7.8%
n	246696	6.9%
S	235266	6.6%
1	227026	6.4%
t	176397	4.9%
a	140160	3.9%
b	132162	3.7%
Other values (32)	1113475	31.2%

cupo_tipo_habitacion
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	10
Missing (%)	< 0.1%
Memory size	1.5 MiB

2.0	202992

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	608976
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	2.0
3rd row	2.0
4th row	2.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
2.0	202992	> 99.9%
(Missing)	10	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2.0	202992	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	202992	33.3%
.	202992	33.3%
0	202992	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	608976	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	202992	33.3%
.	202992	33.3%
0	202992	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	608976	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	202992	33.3%
.	202992	33.3%
0	202992	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	608976	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	202992	33.3%
.	202992	33.3%
0	202992	33.3%

clasificacion_tipo_habitacion
Categorical

High correlation

Distinct	11
Distinct (%)	< 0.1%
Missing	10
Missing (%)	< 0.1%
Memory size	198.8 KiB

Gsu	80304
Ast	51281
Asb	43398
Mst	11124
Mjs	9642
Other values (6)	7243

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	608976
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mst
2nd row	Mst
3rd row	Mjs
4th row	Mjs
5th row	Gsu

Common Values

Value	Count	Frequency (%)
Gsu	80304	39.6%
Ast	51281	25.3%
Asb	43398	21.4%
Mst	11124	5.5%
Mjs	9642	4.7%
Gms	2152	1.1%
Ajs	1808	0.9%
Afm	1793	0.9%
Asd	1156	0.6%
Asp	216	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
gsu	80304	39.6%
ast	51281	25.3%
asb	43398	21.4%
mst	11124	5.5%
mjs	9642	4.7%
gms	2152	1.1%
ajs	1808	0.9%
afm	1793	0.9%
asd	1156	0.6%
asp	216	0.1%

Most occurring characters

Value	Count	Frequency (%)
s	201199	33.0%
A	99652	16.4%
G	82574	13.6%
u	80304	13.2%
t	62405	10.2%
b	43398	7.1%
M	20766	3.4%
j	11450	1.9%
m	3945	0.6%
f	1793	0.3%
Other values (2)	1490	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	608976	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	201199	33.0%
A	99652	16.4%
G	82574	13.6%
u	80304	13.2%
t	62405	10.2%
b	43398	7.1%
M	20766	3.4%
j	11450	1.9%
m	3945	0.6%
f	1793	0.3%
Other values (2)	1490	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	608976	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	201199	33.0%
A	99652	16.4%
G	82574	13.6%
u	80304	13.2%
t	62405	10.2%
b	43398	7.1%
M	20766	3.4%
j	11450	1.9%
m	3945	0.6%
f	1793	0.3%
Other values (2)	1490	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	608976	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	201199	33.0%
A	99652	16.4%
G	82574	13.6%
u	80304	13.2%
t	62405	10.2%
b	43398	7.1%
M	20766	3.4%
j	11450	1.9%
m	3945	0.6%
f	1793	0.3%
Other values (2)	1490	0.2%

id_canal
Categorical

High correlation

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	199.0 KiB

1	82255
4	80877
10	19743
7	6805
0	6378
Other values (9)	6944

Length

Max length	2
Median length	1
Mean length	1.1086393
Min length	1

Characters and Unicode

Total characters	225056
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10
2nd row	10
3rd row	10
4th row	10
5th row	13

Common Values

Value	Count	Frequency (%)
1	82255	40.5%
4	80877	39.8%
10	19743	9.7%
7	6805	3.4%
0	6378	3.1%
8	2225	1.1%
13	1960	1.0%
9	1092	0.5%
5	896	0.4%
11	347	0.2%
Other values (4)	424	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1	82255	40.5%
4	80877	39.8%
10	19743	9.7%
7	6805	3.4%
0	6378	3.1%
8	2225	1.1%
13	1960	1.0%
9	1092	0.5%
5	896	0.4%
11	347	0.2%
Other values (4)	424	0.2%

Most occurring characters

Value	Count	Frequency (%)
1	104656	46.5%
4	80877	35.9%
0	26121	11.6%
7	6805	3.0%
8	2225	1.0%
3	2120	0.9%
9	1092	0.5%
5	896	0.4%
2	144	0.1%
6	120	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	225056	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	104656	46.5%
4	80877	35.9%
0	26121	11.6%
7	6805	3.0%
8	2225	1.0%
3	2120	0.9%
9	1092	0.5%
5	896	0.4%
2	144	0.1%
6	120	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	225056	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	104656	46.5%
4	80877	35.9%
0	26121	11.6%
7	6805	3.0%
8	2225	1.0%
3	2120	0.9%
9	1092	0.5%
5	896	0.4%
2	144	0.1%
6	120	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	225056	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	104656	46.5%
4	80877	35.9%
0	26121	11.6%
7	6805	3.0%
8	2225	1.0%
3	2120	0.9%
9	1092	0.5%
5	896	0.4%
2	144	0.1%
6	120	0.1%

nombre_canal
Categorical

High correlation

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	199.0 KiB

Lada 800 Nacional68	82255
Directo	80877
Multivacaciones 2	19743
Internet	6805
Sin Definir	6378
Other values (9)	6944

Length

Max length	22
Median length	19
Mean length	13.119925
Min length	3

Characters and Unicode

Total characters	2663371
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Multivacaciones 2
2nd row	Multivacaciones 2
3rd row	Multivacaciones 2
4th row	Multivacaciones 2
5th row	Vertical Booking

Common Values

Value	Count	Frequency (%)
Lada 800 Nacional68	82255	40.5%
Directo	80877	39.8%
Multivacaciones 2	19743	9.7%
Internet	6805	3.4%
Sin Definir	6378	3.1%
Fax	2225	1.1%
Vertical Booking	1960	1.0%
Directo Hotel	1092	0.5%
Conmutador	896	0.4%
Multivacaciones 1	347	0.2%
Other values (4)	424	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
lada	82555	20.8%
800	82555	20.8%
nacional68	82255	20.7%
directo	81969	20.6%
multivacaciones	20090	5.1%
2	19743	5.0%
internet	6805	1.7%
sin	6378	1.6%
definir	6378	1.6%
fax	2225	0.6%
Other values (10)	6683	1.7%

Most occurring characters

Value	Count	Frequency (%)
a	375481	14.1%
i	227890	8.6%
c	206664	7.8%
	194634	7.3%
o	191550	7.2%
0	165250	6.2%
8	164810	6.2%
n	132427	5.0%
e	125259	4.7%
t	119781	4.5%
Other values (27)	759625	28.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2663371	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	375481	14.1%
i	227890	8.6%
c	206664	7.8%
	194634	7.3%
o	191550	7.2%
0	165250	6.2%
8	164810	6.2%
n	132427	5.0%
e	125259	4.7%
t	119781	4.5%
Other values (27)	759625	28.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2663371	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	375481	14.1%
i	227890	8.6%
c	206664	7.8%
	194634	7.3%
o	191550	7.2%
0	165250	6.2%
8	164810	6.2%
n	132427	5.0%
e	125259	4.7%
t	119781	4.5%
Other values (27)	759625	28.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2663371	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	375481	14.1%
i	227890	8.6%
c	206664	7.8%
	194634	7.3%
o	191550	7.2%
0	165250	6.2%
8	164810	6.2%
n	132427	5.0%
e	125259	4.7%
t	119781	4.5%
Other values (27)	759625	28.5%

id_pais_origen
Categorical

High correlation Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.6 KiB

157	201504
0	646
232	624
38	228

Length

Max length	3
Median length	3
Mean length	2.9925124
Min length	1

Characters and Unicode

Total characters	607486
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	157
2nd row	157
3rd row	157
4th row	157
5th row	157

Common Values

Value	Count	Frequency (%)
157	201504	99.3%
0	646	0.3%
232	624	0.3%
38	228	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
157	201504	99.3%
0	646	0.3%
232	624	0.3%
38	228	0.1%

Most occurring characters

Value	Count	Frequency (%)
1	201504	33.2%
5	201504	33.2%
7	201504	33.2%
2	1248	0.2%
3	852	0.1%
0	646	0.1%
8	228	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	607486	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	201504	33.2%
5	201504	33.2%
7	201504	33.2%
2	1248	0.2%
3	852	0.1%
0	646	0.1%
8	228	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	607486	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	201504	33.2%
5	201504	33.2%
7	201504	33.2%
2	1248	0.2%
3	852	0.1%
0	646	0.1%
8	228	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	607486	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	201504	33.2%
5	201504	33.2%
7	201504	33.2%
2	1248	0.2%
3	852	0.1%
0	646	0.1%
8	228	< 0.1%

nombre_pais_origen
Categorical

High correlation Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.6 KiB

Mexico	201504
Sin Definir	646
United States	624
Canada	228

Length

Max length	13
Median length	6
Mean length	6.0374282
Min length	6

Characters and Unicode

Total characters	1225610
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mexico
2nd row	Mexico
3rd row	Mexico
4th row	Mexico
5th row	Mexico

Common Values

Value	Count	Frequency (%)
Mexico	201504	99.3%
Sin Definir	646	0.3%
United States	624	0.3%
Canada	228	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mexico	201504	98.6%
sin	646	0.3%
definir	646	0.3%
united	624	0.3%
states	624	0.3%
canada	228	0.1%

Most occurring characters

Value	Count	Frequency (%)
i	204066	16.7%
e	203398	16.6%
M	201504	16.4%
x	201504	16.4%
c	201504	16.4%
o	201504	16.4%
n	2144	0.2%
t	1872	0.2%
a	1308	0.1%
S	1270	0.1%
Other values (8)	5536	0.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1225610	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	204066	16.7%
e	203398	16.6%
M	201504	16.4%
x	201504	16.4%
c	201504	16.4%
o	201504	16.4%
n	2144	0.2%
t	1872	0.2%
a	1308	0.1%
S	1270	0.1%
Other values (8)	5536	0.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1225610	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	204066	16.7%
e	203398	16.6%
M	201504	16.4%
x	201504	16.4%
c	201504	16.4%
o	201504	16.4%
n	2144	0.2%
t	1872	0.2%
a	1308	0.1%
S	1270	0.1%
Other values (8)	5536	0.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1225610	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	204066	16.7%
e	203398	16.6%
M	201504	16.4%
x	201504	16.4%
c	201504	16.4%
o	201504	16.4%
n	2144	0.2%
t	1872	0.2%
a	1308	0.1%
S	1270	0.1%
Other values (8)	5536	0.5%

reservacion_pendiente
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.4 KiB

True	102199
False	100803

Value	Count	Frequency (%)
True	102199	50.3%
False	100803	49.7%

id_estatus_reservacion
Categorical

High correlation

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.7 KiB

9	131069
2	33301
5	18880
1	17158
3	1854
Other values (3)	740

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	203002
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9
2nd row	9
3rd row	9
4th row	9
5th row	9

Common Values

Value	Count	Frequency (%)
9	131069	64.6%
2	33301	16.4%
5	18880	9.3%
1	17158	8.5%
3	1854	0.9%
4	586	0.3%
8	130	0.1%
7	24	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
9	131069	64.6%
2	33301	16.4%
5	18880	9.3%
1	17158	8.5%
3	1854	0.9%
4	586	0.3%
8	130	0.1%
7	24	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
9	131069	64.6%
2	33301	16.4%
5	18880	9.3%
1	17158	8.5%
3	1854	0.9%
4	586	0.3%
8	130	0.1%
7	24	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	131069	64.6%
2	33301	16.4%
5	18880	9.3%
1	17158	8.5%
3	1854	0.9%
4	586	0.3%
8	130	0.1%
7	24	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	131069	64.6%
2	33301	16.4%
5	18880	9.3%
1	17158	8.5%
3	1854	0.9%
4	586	0.3%
8	130	0.1%
7	24	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	131069	64.6%
2	33301	16.4%
5	18880	9.3%
1	17158	8.5%
3	1854	0.9%
4	586	0.3%
8	130	0.1%
7	24	< 0.1%

nombre_estatus_reservacion
Categorical

High correlation

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.7 KiB

Salida	131069
Reservacion Cancelada	33301
Rooming List	18880
Reservacion O (r)registro	17158
No Show	1854
Other values (3)	740

Length

Max length	25
Median length	6
Mean length	10.696826
Min length	6

Characters and Unicode

Total characters	2171477
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Salida
2nd row	Salida
3rd row	Salida
4th row	Salida
5th row	Salida

Common Values

Value	Count	Frequency (%)
Salida	131069	64.6%
Reservacion Cancelada	33301	16.4%
Rooming List	18880	9.3%
Reservacion O (r)registro	17158	8.5%
No Show	1854	0.9%
Reservacion En Transicion	586	0.3%
En Casa (registro)	130	0.1%
Preregistro	24	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
salida	131069	44.8%
reservacion	51045	17.4%
cancelada	33301	11.4%
rooming	18880	6.4%
list	18880	6.4%
o	17158	5.9%
r)registro	17158	5.9%
no	1854	0.6%
show	1854	0.6%
en	716	0.2%
Other values (4)	870	0.3%

Most occurring characters

Value	Count	Frequency (%)
a	413932	19.1%
i	238358	11.0%
l	164370	7.6%
d	164370	7.6%
e	152727	7.0%
S	132923	6.1%
o	110411	5.1%
n	105114	4.8%
r	103437	4.8%
	89783	4.1%
Other values (18)	496052	22.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2171477	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	413932	19.1%
i	238358	11.0%
l	164370	7.6%
d	164370	7.6%
e	152727	7.0%
S	132923	6.1%
o	110411	5.1%
n	105114	4.8%
r	103437	4.8%
	89783	4.1%
Other values (18)	496052	22.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2171477	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	413932	19.1%
i	238358	11.0%
l	164370	7.6%
d	164370	7.6%
e	152727	7.0%
S	132923	6.1%
o	110411	5.1%
n	105114	4.8%
r	103437	4.8%
	89783	4.1%
Other values (18)	496052	22.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2171477	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	413932	19.1%
i	238358	11.0%
l	164370	7.6%
d	164370	7.6%
e	152727	7.0%
S	132923	6.1%
o	110411	5.1%
n	105114	4.8%
r	103437	4.8%
	89783	4.1%
Other values (18)	496052	22.8%

clave_estado
Categorical

High cardinality Imbalance

Distinct	148
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	401.8 KiB

Egr	62426
Emc	55473
Emx	18770
Egt	17465
Edf	9142
Other values (143)	39726

Length

Max length	4
Median length	3
Mean length	3.0177831
Min length	0

Characters and Unicode

Total characters	612616
Distinct characters	31
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Emx
2nd row	Egt
3rd row	Emc
4th row	Egt
5th row	Emx

Common Values

Value	Count	Frequency (%)
Egr	62426	30.8%
Emc	55473	27.3%
Emx	18770	9.2%
Egt	17465	8.6%
Edf	9142	4.5%
Eqe	5596	2.8%
Ehg	5317	2.6%
Eagu	3164	1.6%
Eqr	2775	1.4%
Eca	2613	1.3%
Other values (138)	20261	10.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
egr	62426	30.8%
emc	55473	27.3%
emx	18770	9.2%
egt	17465	8.6%
edf	9142	4.5%
eqe	5596	2.8%
ehg	5317	2.6%
eagu	3164	1.6%
eqr	2775	1.4%
eca	2613	1.3%
Other values (137)	20259	10.0%

Most occurring characters

Value	Count	Frequency (%)
E	203000	33.1%
g	88648	14.5%
m	75932	12.4%
r	65819	10.7%
c	61412	10.0%
x	19154	3.1%
t	18511	3.0%
a	11317	1.8%
d	9316	1.5%
f	9276	1.5%
Other values (21)	50231	8.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	612616	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	203000	33.1%
g	88648	14.5%
m	75932	12.4%
r	65819	10.7%
c	61412	10.0%
x	19154	3.1%
t	18511	3.0%
a	11317	1.8%
d	9316	1.5%
f	9276	1.5%
Other values (21)	50231	8.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	612616	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	203000	33.1%
g	88648	14.5%
m	75932	12.4%
r	65819	10.7%
c	61412	10.0%
x	19154	3.1%
t	18511	3.0%
a	11317	1.8%
d	9316	1.5%
f	9276	1.5%
Other values (21)	50231	8.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	612616	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	203000	33.1%
g	88648	14.5%
m	75932	12.4%
r	65819	10.7%
c	61412	10.0%
x	19154	3.1%
t	18511	3.0%
a	11317	1.8%
d	9316	1.5%
f	9276	1.5%
Other values (21)	50231	8.2%

nombre_estado
Categorical

High cardinality Imbalance

Distinct	144
Distinct (%)	0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	401.8 KiB

Guerrero	62426
Michoacán	55473
México	18770
Guanajuato	17465
Distrito Federal	9142
Other values (139)	39724

Length

Max length	30
Median length	27
Mean length	8.9514631
Min length	4

Characters and Unicode

Total characters	1817147
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	México
2nd row	Guanajuato
3rd row	Michoacán
4th row	Guanajuato
5th row	México

Common Values

Value	Count	Frequency (%)
Guerrero	62426	30.8%
Michoacán	55473	27.3%
México	18770	9.2%
Guanajuato	17465	8.6%
Distrito Federal	9142	4.5%
Querétaro	5596	2.8%
Hidalgo	5317	2.6%
Aguascalientes	3164	1.6%
Quintana Roo	2775	1.4%
California	2613	1.3%
Other values (134)	20259	10.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
guerrero	62426	28.0%
michoacán	55473	24.9%
méxico	18770	8.4%
guanajuato	17465	7.8%
distrito	9152	4.1%
federal	9142	4.1%
querétaro	5596	2.5%
hidalgo	5317	2.4%
aguascalientes	3164	1.4%
quintana	2775	1.2%
Other values (173)	33406	15.0%

Most occurring characters

Value	Count	Frequency (%)
r	228601	12.6%
o	198703	10.9%
a	169367	9.3%
e	163094	9.0%
c	137622	7.6%
i	127571	7.0%
u	117554	6.5%
n	94244	5.2%
G	80121	4.4%
M	75826	4.2%
Other values (47)	424444	23.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1817147	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	228601	12.6%
o	198703	10.9%
a	169367	9.3%
e	163094	9.0%
c	137622	7.6%
i	127571	7.0%
u	117554	6.5%
n	94244	5.2%
G	80121	4.4%
M	75826	4.2%
Other values (47)	424444	23.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1817147	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	228601	12.6%
o	198703	10.9%
a	169367	9.3%
e	163094	9.0%
c	137622	7.6%
i	127571	7.0%
u	117554	6.5%
n	94244	5.2%
G	80121	4.4%
M	75826	4.2%
Other values (47)	424444	23.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1817147	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	228601	12.6%
o	198703	10.9%
a	169367	9.3%
e	163094	9.0%
c	137622	7.6%
i	127571	7.0%
u	117554	6.5%
n	94244	5.2%
G	80121	4.4%
M	75826	4.2%
Other values (47)	424444	23.4%

total_tarifa
Real number (ℝ)

High correlation Skewed Zeros

Distinct	11596
Distinct (%)	5.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4106.7283

Minimum	-30910
Maximum	1033056
Zeros	106391
Zeros (%)	52.4%
Negative	33
Negative (%)	< 0.1%
Memory size	1.5 MiB

Quantile statistics

Minimum	-30910
5-th percentile	0
Q1	0
median	0
Q3	7592
95-th percentile	14720
Maximum	1033056
Range	1063966
Interquartile range (IQR)	7592

Descriptive statistics

Standard deviation	6501.7072
Coefficient of variation (CV)	1.5831841
Kurtosis	3619.6509
Mean	4106.7283
Median Absolute Deviation (MAD)	0
Skewness	26.894022
Sum	8.3367407 × 10⁸
Variance	42272197
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	106391	52.4%
5392	1474	0.7%
7236	1283	0.6%
8088	900	0.4%
7662	870	0.4%
7960	859	0.4%
8514	803	0.4%
5108	800	0.4%
6810	796	0.4%
7878	635	0.3%
Other values (11586)	88191	43.4%

Value	Count	Frequency (%)
-30910	7	< 0.1%
-29950	1	< 0.1%
-20000	7	< 0.1%
-3087	16	< 0.1%
-1345.6	1	< 0.1%
-3	1	< 0.1%
0	106391	52.4%
0.08	3	< 0.1%
0.09	2	< 0.1%
0.14	4	< 0.1%

Value	Count	Frequency (%)
1033056	1	< 0.1%
655848	1	< 0.1%
268632	1	< 0.1%
201474	1	< 0.1%
166296	1	< 0.1%
145544	1	< 0.1%
132946.8	7	< 0.1%
122500	1	< 0.1%
105000	1	< 0.1%
102816	1	< 0.1%

id_moneda
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.5 KiB

1	203002

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	203002
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	203002	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	203002	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	203002	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	203002	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	203002	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	203002	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	203002	100.0%

fecha_ultimo_cambio
Date

Distinct	520
Distinct (%)	0.3%
Missing	497
Missing (%)	0.2%
Memory size	1.5 MiB

Minimum	2019-01-02 00:00:00
Maximum	2020-12-07 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

reservacion
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.4 KiB

True	102199
False	100803

Value	Count	Frequency (%)
True	102199	50.3%
False	100803	49.7%

reservacion_anio_anterior
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.4 KiB

False	102199
True	100803

Value	Count	Frequency (%)
False	102199	50.3%
True	100803	49.7%

id_cliente_disp
Categorical

High correlation Imbalance

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	199.0 KiB

0	100803
2	80295
3	12016
1	5654
4	2962
Other values (11)	1272

Length

Max length	2
Median length	1
Mean length	1.0004433
Min length	1

Characters and Unicode

Total characters	203092
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	4
3rd row	2
4th row	3
5th row	2

Common Values

Value	Count	Frequency (%)
0	100803	49.7%
2	80295	39.6%
3	12016	5.9%
1	5654	2.8%
4	2962	1.5%
5	536	0.3%
6	427	0.2%
8	156	0.1%
7	43	< 0.1%
15	24	< 0.1%
Other values (6)	86	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0	100803	49.7%
2	80295	39.6%
3	12016	5.9%
1	5654	2.8%
4	2962	1.5%
5	536	0.3%
6	427	0.2%
8	156	0.1%
7	43	< 0.1%
15	24	< 0.1%
Other values (6)	86	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	100826	49.6%
2	80317	39.5%
3	12020	5.9%
1	5753	2.8%
4	2970	1.5%
5	560	0.3%
6	427	0.2%
8	156	0.1%
7	43	< 0.1%
9	20	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	203092	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	100826	49.6%
2	80317	39.5%
3	12020	5.9%
1	5753	2.8%
4	2970	1.5%
5	560	0.3%
6	427	0.2%
8	156	0.1%
7	43	< 0.1%
9	20	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	203092	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	100826	49.6%
2	80317	39.5%
3	12020	5.9%
1	5753	2.8%
4	2970	1.5%
5	560	0.3%
6	427	0.2%
8	156	0.1%
7	43	< 0.1%
9	20	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	203092	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	100826	49.6%
2	80317	39.5%
3	12020	5.9%
1	5753	2.8%
4	2970	1.5%
5	560	0.3%
6	427	0.2%
8	156	0.1%
7	43	< 0.1%
9	20	< 0.1%

cliente_disp_anio_anterior
Real number (ℝ)

High correlation Zeros

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0796938

Minimum	0
Maximum	15
Zeros	102199
Zeros (%)	50.3%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	3
Maximum	15
Range	15
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.2046937
Coefficient of variation (CV)	1.1157735
Kurtosis	4.2151962
Mean	1.0796938
Median Absolute Deviation (MAD)	0
Skewness	1.0595136
Sum	219180
Variance	1.451287
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	102199	50.3%
2	79038	38.9%
3	11946	5.9%
1	5638	2.8%
4	2933	1.4%
5	534	0.3%
6	422	0.2%
8	143	0.1%
7	43	< 0.1%
10	23	< 0.1%
Other values (6)	83	< 0.1%

Value	Count	Frequency (%)
0	102199	50.3%
1	5638	2.8%
2	79038	38.9%
3	11946	5.9%
4	2933	1.4%
5	534	0.3%
6	422	0.2%
7	43	< 0.1%
8	143	0.1%
9	19	< 0.1%

Value	Count	Frequency (%)
15	23	< 0.1%
14	8	< 0.1%
13	4	< 0.1%
12	20	< 0.1%
11	9	< 0.1%
10	23	< 0.1%
9	19	< 0.1%
8	143	0.1%
7	43	< 0.1%
6	422	0.2%

Interactions

Correlations

	ciudad_agencia	clasificacion_tipo_habitacion	cliente_disp_anio_anterior	entidad_federativa_agencia	id_canal	id_cliente_disp	id_estatus_reservacion	id_pais_origen	id_paquete	id_programa	id_reservaciones	id_segmento	id_tipo_habitacion	nombre_canal	nombre_estatus_reservacion	nombre_pais_origen	nombre_paquete	nombre_programa	nombre_segmento	nombre_tipo_habitacion	numero_adultos	numero_adultos_anio_anterior	numero_menores	numero_menores_anio_anterior	numero_noches	numero_noches_anio_anterior	numero_personas	numero_personas_anio_anterior	pais_agencia	reservacion	reservacion_anio_anterior	reservacion_pendiente	total_habitaciones	total_habitaciones_anio_anterior	total_tarifa
ciudad_agencia	1.000	0.227	0.097	0.996	0.332	0.086	0.202	0.128	0.333	0.418	0.128	0.552	0.161	0.332	0.202	0.128	0.333	0.418	0.552	0.161	0.098	0.097	0.023	0.023	0.000	0.000	0.091	0.090	1.000	0.000	0.000	0.000	0.039	0.038	0.000
clasificacion_tipo_habitacion	0.227	1.000	0.111	0.182	0.210	0.113	0.168	0.024	0.042	0.059	0.059	0.252	1.000	0.210	0.168	0.024	0.042	0.059	0.252	1.000	0.112	0.111	0.032	0.032	0.000	0.000	0.107	0.107	0.058	0.000	0.000	0.000	0.046	0.046	0.015
cliente_disp_anio_anterior	0.097	0.111	1.000	0.080	0.083	0.315	0.035	0.000	0.019	0.005	0.833	0.104	0.117	0.083	0.035	0.000	0.019	0.005	0.104	0.117	-0.921	1.000	-0.145	0.170	-0.892	0.901	-0.911	0.982	0.020	0.946	0.946	0.946	-0.957	0.958	-0.849
entidad_federativa_agencia	0.996	0.182	0.080	1.000	0.275	0.071	0.142	0.122	0.241	0.112	0.082	0.440	0.143	0.275	0.142	0.122	0.241	0.112	0.440	0.143	0.081	0.080	0.017	0.017	0.000	0.000	0.071	0.071	1.000	0.000	0.000	0.000	0.033	0.032	0.000
id_canal	0.332	0.210	0.083	0.275	1.000	0.077	0.208	0.182	0.356	0.274	0.080	0.351	0.215	1.000	0.208	0.182	0.356	0.274	0.351	0.215	0.083	0.083	0.037	0.036	0.000	0.000	0.085	0.085	0.181	0.000	0.000	0.000	0.045	0.044	0.003
id_cliente_disp	0.086	0.113	0.315	0.071	0.077	1.000	0.068	0.005	0.031	0.016	0.333	0.091	0.102	0.077	0.068	0.005	0.031	0.016	0.091	0.102	1.000	0.315	0.377	0.038	0.011	0.000	0.647	0.087	0.036	1.000	1.000	1.000	0.421	0.407	0.000
id_estatus_reservacion	0.202	0.168	0.035	0.142	0.208	0.068	1.000	0.052	0.180	0.154	0.175	0.177	0.188	0.208	1.000	0.052	0.180	0.154	0.177	0.188	0.039	0.035	0.030	0.030	0.000	0.002	0.042	0.042	0.062	0.017	0.017	0.017	0.039	0.038	0.027
id_pais_origen	0.128	0.024	0.000	0.122	0.182	0.005	0.052	1.000	0.034	0.002	0.032	0.122	0.032	0.182	0.052	1.000	0.034	0.002	0.122	0.032	0.000	0.000	0.000	0.000	0.007	0.000	0.004	0.004	0.092	0.000	0.000	0.000	0.000	0.000	0.000
id_paquete	0.333	0.042	0.019	0.241	0.356	0.031	0.180	0.034	1.000	1.000	0.045	0.293	0.065	0.356	0.180	0.034	1.000	1.000	0.293	0.065	0.019	0.019	0.018	0.018	0.000	0.000	0.021	0.021	0.088	0.000	0.000	0.000	0.028	0.027	0.000
id_programa	0.418	0.059	0.005	0.112	0.274	0.016	0.154	0.002	1.000	1.000	0.057	0.157	0.066	0.274	0.154	0.002	1.000	0.999	0.157	0.066	0.004	0.005	0.000	0.000	0.000	0.000	0.010	0.010	0.010	0.000	0.000	0.000	0.049	0.049	0.000
id_reservaciones	0.128	0.059	0.833	0.082	0.080	0.333	0.175	0.032	0.045	0.057	1.000	0.080	0.066	0.080	0.175	0.032	0.045	0.057	0.080	0.066	-0.829	0.833	-0.143	0.119	-0.812	0.799	-0.817	0.829	0.062	0.993	0.993	0.993	-0.864	0.862	-0.767
id_segmento	0.552	0.252	0.104	0.440	0.351	0.091	0.177	0.122	0.293	0.157	0.080	1.000	0.212	0.351	0.177	0.122	0.293	0.157	1.000	0.212	0.106	0.104	0.032	0.032	0.031	0.028	0.104	0.103	0.501	0.000	0.000	0.000	0.050	0.049	0.008
id_tipo_habitacion	0.161	1.000	0.117	0.143	0.215	0.102	0.188	0.032	0.065	0.066	0.066	0.212	1.000	0.215	0.188	0.032	0.065	0.066	0.212	1.000	0.118	0.117	0.037	0.037	0.055	0.054	0.115	0.114	0.081	0.000	0.000	0.000	0.055	0.054	0.014
nombre_canal	0.332	0.210	0.083	0.275	1.000	0.077	0.208	0.182	0.356	0.274	0.080	0.351	0.215	1.000	0.208	0.182	0.356	0.274	0.351	0.215	0.083	0.083	0.037	0.036	0.000	0.000	0.085	0.085	0.181	0.000	0.000	0.000	0.045	0.044	0.003
nombre_estatus_reservacion	0.202	0.168	0.035	0.142	0.208	0.068	1.000	0.052	0.180	0.154	0.175	0.177	0.188	0.208	1.000	0.052	0.180	0.154	0.177	0.188	0.039	0.035	0.030	0.030	0.000	0.002	0.042	0.042	0.062	0.017	0.017	0.017	0.039	0.038	0.027
nombre_pais_origen	0.128	0.024	0.000	0.122	0.182	0.005	0.052	1.000	0.034	0.002	0.032	0.122	0.032	0.182	0.052	1.000	0.034	0.002	0.122	0.032	0.000	0.000	0.000	0.000	0.007	0.000	0.004	0.004	0.092	0.000	0.000	0.000	0.000	0.000	0.000
nombre_paquete	0.333	0.042	0.019	0.241	0.356	0.031	0.180	0.034	1.000	1.000	0.045	0.293	0.065	0.356	0.180	0.034	1.000	1.000	0.293	0.065	0.019	0.019	0.018	0.018	0.000	0.000	0.021	0.021	0.088	0.000	0.000	0.000	0.028	0.027	0.000
nombre_programa	0.418	0.059	0.005	0.112	0.274	0.016	0.154	0.002	1.000	0.999	0.057	0.157	0.066	0.274	0.154	0.002	1.000	1.000	0.157	0.066	0.004	0.005	0.000	0.000	0.000	0.000	0.010	0.010	0.010	0.000	0.000	0.000	0.049	0.049	0.000
nombre_segmento	0.552	0.252	0.104	0.440	0.351	0.091	0.177	0.122	0.293	0.157	0.080	1.000	0.212	0.351	0.177	0.122	0.293	0.157	1.000	0.212	0.106	0.104	0.032	0.032	0.031	0.028	0.104	0.103	0.501	0.000	0.000	0.000	0.050	0.049	0.008
nombre_tipo_habitacion	0.161	1.000	0.117	0.143	0.215	0.102	0.188	0.032	0.065	0.066	0.066	0.212	1.000	0.215	0.188	0.032	0.065	0.066	0.212	1.000	0.118	0.117	0.037	0.037	0.055	0.054	0.115	0.114	0.081	0.000	0.000	0.000	0.055	0.054	0.014
numero_adultos	0.098	0.112	-0.921	0.081	0.083	1.000	0.039	0.000	0.019	0.004	-0.829	0.106	0.118	0.083	0.039	0.000	0.019	0.004	0.106	0.118	1.000	-0.921	0.169	-0.146	0.898	-0.893	0.981	-0.912	0.020	0.946	0.946	0.946	0.957	-0.956	0.857
numero_adultos_anio_anterior	0.097	0.111	1.000	0.080	0.083	0.315	0.035	0.000	0.019	0.005	0.833	0.104	0.117	0.083	0.035	0.000	0.019	0.005	0.104	0.117	-0.921	1.000	-0.145	0.170	-0.892	0.901	-0.911	0.982	0.020	0.946	0.946	0.946	-0.957	0.958	-0.849
numero_menores	0.023	0.032	-0.145	0.017	0.037	0.377	0.030	0.000	0.018	0.000	-0.143	0.032	0.037	0.037	0.030	0.000	0.018	0.000	0.032	0.037	0.169	-0.145	1.000	-0.023	0.157	-0.141	0.258	-0.144	0.000	0.095	0.095	0.095	0.155	-0.150	0.130
numero_menores_anio_anterior	0.023	0.032	0.170	0.017	0.036	0.038	0.030	0.000	0.018	0.000	0.119	0.032	0.037	0.036	0.030	0.000	0.018	0.000	0.032	0.037	-0.146	0.170	-0.023	1.000	-0.141	0.158	-0.144	0.257	0.000	0.096	0.096	0.096	-0.152	0.156	-0.135
numero_noches	0.000	0.000	-0.892	0.000	0.000	0.011	0.000	0.007	0.000	0.000	-0.812	0.031	0.055	0.000	0.000	0.007	0.000	0.000	0.031	0.055	0.898	-0.892	0.157	-0.141	1.000	-0.864	0.889	-0.883	0.000	0.007	0.007	0.007	0.928	-0.925	0.849
numero_noches_anio_anterior	0.000	0.000	0.901	0.000	0.000	0.000	0.002	0.000	0.000	0.000	0.799	0.028	0.054	0.000	0.002	0.000	0.000	0.000	0.028	0.054	-0.893	0.901	-0.141	0.158	-0.864	1.000	-0.884	0.892	0.000	0.006	0.006	0.006	-0.928	0.930	-0.823
numero_personas	0.091	0.107	-0.911	0.071	0.085	0.647	0.042	0.004	0.021	0.010	-0.817	0.104	0.115	0.085	0.042	0.004	0.021	0.010	0.104	0.115	0.981	-0.911	0.258	-0.144	0.889	-0.884	1.000	-0.902	0.015	0.230	0.230	0.230	0.947	-0.946	0.844
numero_personas_anio_anterior	0.090	0.107	0.982	0.071	0.085	0.087	0.042	0.004	0.021	0.010	0.829	0.103	0.114	0.085	0.042	0.004	0.021	0.010	0.103	0.114	-0.912	0.982	-0.144	0.257	-0.883	0.892	-0.902	1.000	0.015	0.232	0.232	0.232	-0.947	0.949	-0.841
pais_agencia	1.000	0.058	0.020	1.000	0.181	0.036	0.062	0.092	0.088	0.010	0.062	0.501	0.081	0.181	0.062	0.092	0.088	0.010	0.501	0.081	0.020	0.020	0.000	0.000	0.000	0.000	0.015	0.015	1.000	0.000	0.000	0.000	0.002	0.002	0.000
reservacion	0.000	0.000	0.946	0.000	0.000	1.000	0.017	0.000	0.000	0.000	0.993	0.000	0.000	0.000	0.017	0.000	0.000	0.000	0.000	0.000	0.946	0.946	0.095	0.096	0.007	0.006	0.230	0.232	0.000	1.000	1.000	1.000	0.998	0.998	0.010
reservacion_anio_anterior	0.000	0.000	0.946	0.000	0.000	1.000	0.017	0.000	0.000	0.000	0.993	0.000	0.000	0.000	0.017	0.000	0.000	0.000	0.000	0.000	0.946	0.946	0.095	0.096	0.007	0.006	0.230	0.232	0.000	1.000	1.000	1.000	0.998	0.998	0.010
reservacion_pendiente	0.000	0.000	0.946	0.000	0.000	1.000	0.017	0.000	0.000	0.000	0.993	0.000	0.000	0.000	0.017	0.000	0.000	0.000	0.000	0.000	0.946	0.946	0.095	0.096	0.007	0.006	0.230	0.232	0.000	1.000	1.000	1.000	0.998	0.998	0.010
total_habitaciones	0.039	0.046	-0.957	0.033	0.045	0.421	0.039	0.000	0.028	0.049	-0.864	0.050	0.055	0.045	0.039	0.000	0.028	0.049	0.050	0.055	0.957	-0.957	0.155	-0.152	0.928	-0.928	0.947	-0.947	0.002	0.998	0.998	0.998	1.000	-0.993	0.884
total_habitaciones_anio_anterior	0.038	0.046	0.958	0.032	0.044	0.407	0.038	0.000	0.027	0.049	0.862	0.049	0.054	0.044	0.038	0.000	0.027	0.049	0.049	0.054	-0.956	0.958	-0.150	0.156	-0.925	0.930	-0.946	0.949	0.002	0.998	0.998	0.998	-0.993	1.000	-0.881
total_tarifa	0.000	0.015	-0.849	0.000	0.003	0.000	0.027	0.000	0.000	0.000	-0.767	0.008	0.014	0.003	0.027	0.000	0.000	0.000	0.008	0.014	0.857	-0.849	0.130	-0.135	0.849	-0.823	0.844	-0.841	0.000	0.010	0.010	0.010	0.884	-0.881	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	id_reservaciones	fecha_hoy	fecha_reservacion	fecha_llegada	fecha_salida	numero_personas	numero_adultos	numero_noches	total_habitaciones	id_programa	nombre_programa	id_paquete	nombre_paquete	id_segmento	nombre_segmento	id_agencia	nombre_agencia	ciudad_agencia	entidad_federativa_agencia	pais_agencia	id_empresa	nombre_empresa	total_habitaciones_empresa	id_tipo_habitacion	nombre_tipo_habitacion	cupo_tipo_habitacion	clasificacion_tipo_habitacion	id_canal	nombre_canal	id_pais_origen	nombre_pais_origen	reservacion_pendiente	id_estatus_reservacion	nombre_estatus_reservacion	clave_estado	nombre_estado	total_tarifa	id_moneda	fecha_ultimo_cambio	reservacion	reservacion_anio_anterior	id_cliente_disp
0	0	2019-08-16	2019-08-16	2019-07-11	2019-10-11	2	2	3	1	1	Ninguno	1	Walk In	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	25	Estd 2q Sn12mst	2.0	Mst	10	Multivacaciones 2	157	Mexico	True	9	Salida	Emx	México	2659.98	1	2019-10-11	True	False	2
1	1	2019-10-22	2019-10-22	2019-01-12	2019-05-12	4	4	4	1	1	Ninguno	2	Ninguno	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	25	Estd 2q Sn12mst	2.0	Mst	10	Multivacaciones 2	157	Mexico	True	9	Salida	Egt	Guanajuato	1764.00	1	2019-05-12	True	False	4
2	2	2019-10-28	2019-10-28	2019-01-12	2019-05-12	2	2	4	1	1	Ninguno	1	Walk In	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	23	Jr Suite 1k Sn12mjs	2.0	Mjs	10	Multivacaciones 2	157	Mexico	True	9	Salida	Emc	Michoacán	2660.04	1	2019-05-12	True	False	2
3	3	2019-10-28	2019-10-28	2019-08-12	2019-11-12	4	3	3	1	1	Ninguno	2	Ninguno	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	24	Jr Suite 2q Sn12mjs	2.0	Mjs	10	Multivacaciones 2	157	Mexico	True	9	Salida	Egt	Guanajuato	1995.03	1	2019-11-12	True	False	3
4	4	2019-10-28	2019-10-28	2019-08-12	2019-12-12	2	2	4	1	1	Ninguno	1	Walk In	5	Ecommerce Ota Domestic	14	Bestday Travel Group	Cancún	Quintana Roo	México	1	Hotel 1	735	4	Luxury 2q Sn12gsu	2.0	Gsu	13	Vertical Booking	157	Mexico	True	9	Salida	Emx	México	13369.92	1	2019-12-12	True	False	2
5	5	2019-05-08	2019-05-08	2019-01-12	2019-05-12	6	6	4	1	1	Ninguno	1	Walk In	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	24	Jr Suite 2q Sn12mjs	2.0	Mjs	12	Sitio Propio	157	Mexico	True	9	Salida	Egt	Guanajuato	2660.04	1	2019-05-12	True	False	6
6	6	2019-07-19	2019-07-19	2019-08-22	2019-08-25	2	2	3	1	1	Ninguno	1	Walk In	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	25	Estd 2q Sn12mst	2.0	Mst	10	Multivacaciones 2	157	Mexico	True	2	Reservacion Cancelada	Egr	Guerrero	3331.98	1	2019-07-24	True	False	2
7	7	2019-07-19	2019-07-19	2019-08-23	2019-08-25	2	2	2	1	1	Ninguno	1	Walk In	5	Ecommerce Ota Domestic	14	Bestday Travel Group	Cancún	Quintana Roo	México	1	Hotel 1	735	4	Luxury 2q Sn12gsu	2.0	Gsu	1	Lada 800 Nacional68	157	Mexico	True	9	Salida	Emc	Michoacán	8809.92	1	2019-08-25	True	False	2
8	8	2019-07-19	2019-07-19	2019-08-25	2019-08-29	3	2	4	1	1	Ninguno	2	Ninguno	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	26	Mv Luxury 2q Sn12gsu	2.0	Gsu	10	Multivacaciones 2	157	Mexico	True	9	Salida	Egr	Guerrero	2548.00	1	2019-08-29	True	False	2
9	9	2019-06-05	2019-06-05	2019-08-25	2019-08-29	2	2	4	1	1	Ninguno	2	Ninguno	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	27	Mv Luxury 1k Sn12gsu	2.0	Gsu	10	Multivacaciones 2	157	Mexico	True	9	Salida	Emc	Michoacán	2548.00	1	2019-08-29	True	False	2

	id_reservaciones	fecha_hoy	fecha_reservacion	fecha_llegada	fecha_salida	numero_personas_anio_anterior	numero_adultos_anio_anterior	numero_menores_anio_anterior	numero_noches_anio_anterior	total_habitaciones_anio_anterior	id_programa	nombre_programa	id_paquete	nombre_paquete	id_segmento	nombre_segmento	id_agencia	nombre_agencia	ciudad_agencia	entidad_federativa_agencia	pais_agencia	id_empresa	nombre_empresa	total_habitaciones_empresa	id_tipo_habitacion	nombre_tipo_habitacion	cupo_tipo_habitacion	clasificacion_tipo_habitacion	id_canal	nombre_canal	id_pais_origen	nombre_pais_origen	reservacion_pendiente	id_estatus_reservacion	nombre_estatus_reservacion	clave_estado	nombre_estado	id_moneda	fecha_ultimo_cambio	reservacion	reservacion_anio_anterior	cliente_disp_anio_anterior
202992	202992	2020-05-02	2019-05-02	2019-04-19	2019-04-26	4	2	2	7	1	1	Ninguno	1	Walk In	18	Tour Operators Internationals	116	Sunwing Vacations	Toronto	Ontario	Canada	1	Hotel 1	735	17	Estd C/balcon Sn12asb	2.0	Asb	0	Sin Definir	38	Canada	False	9	Salida	Eca	California	1	2019-04-26	False	True	2
202993	202993	2020-10-04	2019-10-04	2019-10-04	2019-04-13	2	2	0	3	1	1	Ninguno	2	Ninguno	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	19	Estd Db Sn12ast	2.0	Ast	1	Lada 800 Nacional68	0	Sin Definir	False	9	Salida	Emc	Michoacán	1	2019-04-13	False	True	2
202994	202994	2020-10-04	2019-10-04	2019-10-04	2019-04-13	2	2	0	3	1	1	Ninguno	2	Ninguno	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	19	Estd Db Sn12ast	2.0	Ast	1	Lada 800 Nacional68	0	Sin Definir	False	9	Salida	Emc	Michoacán	1	2019-04-13	False	True	2
202995	202995	2020-10-04	2019-10-04	2019-10-04	2019-04-13	2	2	0	3	1	1	Ninguno	2	Ninguno	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	19	Estd Db Sn12ast	2.0	Ast	1	Lada 800 Nacional68	0	Sin Definir	False	9	Salida	Emc	Michoacán	1	2019-04-13	False	True	2
202996	202996	2020-10-04	2019-10-04	2019-10-04	2019-10-04	2	2	0	3	1	1	Ninguno	2	Ninguno	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	19	Estd Db Sn12ast	2.0	Ast	1	Lada 800 Nacional68	0	Sin Definir	False	2	Reservacion Cancelada	Emc	Michoacán	1	2019-10-04	False	True	2
202997	202997	2020-10-04	2019-10-04	2019-10-04	2019-10-04	2	2	0	3	1	1	Ninguno	2	Ninguno	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	19	Estd Db Sn12ast	2.0	Ast	1	Lada 800 Nacional68	0	Sin Definir	False	2	Reservacion Cancelada	Emc	Michoacán	1	2019-10-04	False	True	2
202998	202998	2020-06-17	2019-06-17	2019-06-17	2019-06-17	2	2	0	0	1	1	Ninguno	1	Walk In	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	13	Sup Luj King Sn12asb	2.0	Asb	1	Lada 800 Nacional68	0	Sin Definir	False	9	Salida	Egr	Guerrero	1	2019-06-17	False	True	2
202999	202999	2020-05-30	2019-05-30	2019-05-30	2019-02-06	3	2	0	3	1	1	Ninguno	2	Ninguno	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	17	Estd C/balcon Sn12asb	2.0	Asb	1	Lada 800 Nacional68	0	Sin Definir	False	9	Salida	Emc	Michoacán	1	2019-02-06	False	True	2
203000	203000	2020-10-08	2019-10-08	2019-10-08	2019-12-08	2	2	0	2	1	1	Ninguno	1	Walk In	5	Ecommerce Ota Domestic	14	Bestday Travel Group	Cancún	Quintana Roo	México	1	Hotel 1	735	6	Luxury 1k Sn12gsu	2.0	Gsu	1	Lada 800 Nacional68	0	Sin Definir	False	9	Salida	Emc	Michoacán	1	2019-12-08	False	True	2
203001	203001	2020-02-24	2019-02-24	2019-02-24	2019-02-28	2	2	0	4	1	1	Ninguno	2	Ninguno	14	Individual Ep/vac. Club	112	Hoteles S.a.	Mexico City	México	México	1	Hotel 1	735	25	Estd 2q Sn12mst	2.0	Mst	1	Lada 800 Nacional68	0	Sin Definir	False	9	Salida	Emc	Michoacán	1	2019-02-28	False	True	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length